package com.ateam.dao;

import java.util.List;

import com.ateam.pojo.Users;

/** 
* @author WuYuan
* 
*/
public interface UsersDao {
	public int addUser(Users u)throws Exception;//新增用户
	public Users getUserByEmail(String email)throws Exception;//根据邮箱查重
	public Users getUserByUserid(int userid)throws Exception;//根据用户id得到用户的所有信息
	public Users getUserLogin(Users u)throws Exception;//登录
	public int updateUser(Users u)throws Exception;//修改用户资料
	public List<Users> getUsersByCompanyid(int companyid)throws Exception;//根据公司id获取所有人员
	public List<Users> getUsersByProjectid(int projectid)throws Exception;//根据项目id获取所有人员
	public List<Users> getUsersByNoProjectid(int companyid,int projectid)throws Exception;//根据项目id获取所有非项目内人员
	public int addUserProject(int userid, int projectid)throws Exception;//添加用户到项目
	public List<Users> getUsersByGroupid(int groupid)throws Exception;//根据小组id获取所有人员
	public List<Users> getUsersByNoGroupid(int companyid,int groupid)throws Exception;//根据项目id获取所有非小组内人员
	public int addUserGroup(int userid, int groupid)throws Exception;//添加用户到小组
	public List<Users> getCompanyApplyer(int companyid)throws Exception;//获取申请该公司的用户的信息
}
